Acumen Touchstone 8.1.5 Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Open Plan (BK3) Calculated Fields

This topic contains information about .bk3 calculated fields.

To Calculate... Rules
Activity Constraint / Primary Constraint
  • If ACT_TYPE = ALAP or L, then value is As Late As Possible
  • If TARGSTYPE = None and TARGFTYPE = None, then value is None.
  • If TARGSTYPE = None and TARGFTYPE = No Earlier Than or NE, then value is Finish On Or After.
  • If TARGSTYPE = None and TARGFTYPE = Not Later Than or NL, then value is Finish On Or Before.
  • If TARGSTYPE = None and TARGFTYPE = On Target or ON, then value is Must Finish On.
  • If TARGSTYPE = None and TARGFTYPE = Fixed Target, then value is Mandatory Finish.
  • If TARGSTYPE = Not Earlier Than or NE, then value is Start On Or After.
  • If TARGSTYPE = Not Later Than or NL, then value is Start On Or Before.
  • If TARGSTYPE = On Target or ON, then value is Must Start On.
  • If TARGSTYPE = Fixed Target or FT, then value is Mandatory Start.
Primary Constraint Date
  • If Activity Constraint / Primary Constraint is Start On Or After, Start On Or Before, Must Start On, or Mandatory Start, then value is TSDATE.
  • If Activity Constraint / Primary Constraint is Finish On Or After, Finish On Or Before, Must Finish On, or Mandatory Finish, then value is TFDATE.
Secondary Constraint
  • If Activity Constraint / Primary Constraint is set to Start On Or After, Start On Or Before, Must Start On, or Mandatory Start, then value is:
    • Finish On Or After if TARGFTYPE is Not Earlier Than or NE.
    • Finish On Or Before if TARGFTYPE is Not Later Than or NL.
    • Must Finish On if TARGFTYPE is On Target or ON.
    • Mandatory Finish if TARGFTYPE is Fixed Target or FX.
  • If Activity Constraint / Primary Constraint is Finish On Or After, Finish On Or Before, Must Finish On, or Mandatory Finish, then value is None.
Secondary Constraint Date
  • If Secondary Constraint has a value, then field value is TFDATE.
Activity Status
  • If COMPSTAT is Complete or 2, then value is Complete.
  • If COMSTAT is In Progress or 1, then value is In Progress.
Activity Type
  • If ACT_TYPE is Finish Milestone or F, then value is Finish Milestone.
  • If ACT_TYPE is Start Milestone or S, then value is Milestone.
  • If ACT_TYPE is Hammock or H, then value is Level of Effort.
  • If ACT_TYPE is Subproject, External Subproject, E, or P, then value is Summary.
  • If none of the above, then value is Normal.
Critical and Longest Path
  • If CRITICAL is not Not Critical and not 0, then the value is True, otherwise the value is False.
Duration Percent Complete
  • Value is Remaining Duration / Total Duration.
Earned Value Technique
  • If EVT is Level of Effort or A, then value is Level of Effort.
  • If EVT is Percent Complete or C, then value is Percent Complete.
  • If EVT is 50-50 or E, then value is Fifty Fifty.
  • If EVT is 0-100 or F, then value is Zero Hundred.
  • If EVT is User-Defined Percentage or H, then value is User Defined.
  • If EVT is Planning Package or K, then value is Planning Package.
  • If EVT is Resource % Complete or L, then value is Assignment Percentage Complete.
  • If EVT is anything other than the above, then value is Percent Complete.
Existence %
  • If ACT_PROBABILITY is blank, then value is 100, otherwise value is ACT_PROBABILITY.
Finish Date
  • If AFDATE exists, then use AFDATE, otherwise use EFDATE.
Start Date
  • If ASDATE exists, then use ASDATE, otherwise use ESDATE.
Remaining Duration
  • If PROGTYPE has a value of R, then value is PROGVALUE, otherwise value is REM_DUR.
  • If value of REM_DUR is less than 0, then value is reset to 0.
Is Level of Effort
  • If ACT_TYPE is Hammock or H, then value is TRUE, otherwise value is False.
Remaining Duration Elapsed
  • If PROGTYPE is E, then value is TRUE, otherwise value is False.
Mean Duration or Most Likely Duration
  • If REM_DUR is empty, then value is 0, otherwise value is REM_DUR.
Maximum Lags
  • Find the largest value of lag from the activity's list of successors.
Minimum Lags
  • Find the smallest value of lag from the activity's list of successors.
Number of FS Predecessors
  • Find the number of predecessors of the activity that have a link type of Finish to Start.
Number of FS Successors
  • Find the number of successors of the activity that have a link type of Finish to Start.
Number of SS Predecessors
  • Find the number of predecessors of the activity that have a link type of Start to Start.
Number of SS Successors
  • Find the number of successors of the activity that have a link type of Start to Start.
Number of SF Predecessors
  • Find the number of predecessors of the activity that have a link type of Start to Finish.
Number of SF Successors
  • Find the number of successors of the activity that have a link type of Start to Finish.
Number of FF Predecessors
  • Find the number of predecessors of the activity that have a link type of Finish to Finish.
Number of FF Successors
  • Find the number of successors of the activity that have a link type of Finish to Finish.
Number of Lags
  • Find the number of predecessors of the activity that have a positive value of Lag.
Number of Leads
  • Find the number of predecessors of the activity that have a negative value of Lag.
Number of Predecessors
  • Find the number of predecessors of the activity.
Number of Successors
  • Find the number of successors of the activity.
Percent Complete
  • If PROGTYPE is P, then value is PROGVALUE.
  • If PROGTYPE is C, then value is 1.
  • If PROGTYPE is R, then value is: [(Original Duration in Days) - (Remaining Duration in Days)] / [Original Duration in Days].

    To compute the original duration in days, you must use the calendar for the activity to compute the correct duration units before converting those duration units to days using the calendar's work hours per day.

  • If PROGTYPE is anything else, then value is 0.
Project Time Now
  • If STATDATE has a value, use STATDATE otherwise use STARTDATE.
Total Cost
  • Actual Cost + Remaining Cost.
Total Duration
  • Actual Duration + Remaining Duration.
Units Percent Complete
  • Remaining Units / Total Units.
Percent Complete Type
  • Value is always set to Physical.
WBS
  • If Activity Type is Summary, then value is the WBS' generated GUID.

Touchstone reads external relationships and external activities. This makes the count of relationships more accurate for metrics. External activities from P6 XER schedule or MPP schedules are now part of the list of activities used in calculating a score for an uploaded schedule unless metrics exclude external activities. External activities, however, are excluded from the random selection of activities used in determining the Project Critical Path Test and Logic Sensitivity.